package com.zhizuobiao.dao;

import com.zhizuobiao.entity.QueryTest;
import com.zhizuobiao.entity.User;

import java.util.List;
import java.util.Map;

public interface UserDao {

    User getUser(int id) throws Exception;

    List<User> getUserLike(String username) throws Exception;

    // 测试动态sql if
    List<User> getUserList2(User user) throws Exception;

    // 测试动态sql foreach
    List<User> getUserList3(List list) throws Exception;

    List<User> getUserList(QueryTest query) throws Exception;

    List<User> getUserListOrder(Map order) throws Exception;

    int insertUser(User user) throws Exception;

    // 需要查询所有用户信息，关联查询订单及订单明细信息，订单明细信息中关联查询商品信息
    List<User> getUserListOrders();


    int updateUser(User user);


}
